KNOWHOW2 Logo
Excel 2007 Advanced
The Excel 2007 Advanced tutorial takes you step by step through advanced spreadsheet tasks as specified in the Microsoft Certified Application Specialist (MCAS) exam (77-602).
Data Integrity Templates
Linking Data
Consolidating Workbooks
Validating Data
Working with Hyperlinks
Advanced Functions Lookup Functions
Time and Mathematical Functions
Financial Functions and Data Tables
Logical and Informational Functions
Text Functions
Database Functions
Collaboration Features Using Comments
Sharing and Protecting Workbooks
Tracking Changes in Workbooks
Document Inspector